Window Functions

sql

SELECT column_name1,
       window_function(column_name2)
       OVER ([PARTITION BY column_name3] [ORDER BY column_name4]) AS new_column
FROM table_name;